package com.be.beadmin.device.dto.output;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ContentFontStyle;
import com.alibaba.excel.annotation.write.style.HeadFontStyle;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.util.Date;
@Data
@NoArgsConstructor
@AllArgsConstructor
@ContentFontStyle(fontName = "Microsoft YaHei",fontHeightInPoints = 12)
@HeadFontStyle(fontName = "Microsoft YaHei",fontHeightInPoints = 12)
public class SpareInfoExcelEx {
    @ExcelProperty("仓库名称")
    private String warehouseName;
    @ExcelProperty("仓库编码")
    private String warehouseId;
    @ExcelProperty("备件名称")
    private String spareName;
    @ExcelProperty("备件编码")
    private String spareId;
    @ExcelProperty("库位编码")
    private String locationCode;
    @ExcelProperty("规格型号")
    private String spareType;
    @ExcelProperty("品牌")
    private String manufacturer;
    @ExcelProperty("供应商")
    private String vendor;
    @ExcelProperty("库存数量")
    private float QTY;
//    @ExcelProperty("唯一标识")
//    private String identification;
    @ExcelProperty("单位")
    private String unit;
    @ExcelProperty("可用库存")
    private float availableQTY;
    @ExcelProperty("安全库存")
    private float safeQTY;
    @ExcelProperty("联系人")
    private String contact;
    @ExcelProperty("联系方式")
    private String telephone;
    @ExcelProperty("采购编号")
    private String contractId;
    @ExcelProperty("采购日期")
    @JsonFormat(pattern = "yyyy-MM-dd", timezone = "GMT+8")
    private Date contractDate;

}
